package com.cjack.frenchexcel.model;

import com.sargeraswang.util.ExcelUtil.ExcelCell;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;
import java.util.LinkedHashMap;
import java.util.Map;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class ConsumerExportModel implements Serializable {
    //第0列是行号，不处理
    @ExcelCell(index = 1)
    private String dateDeDepense;//日期
    @ExcelCell(index = 2)
    private String number;
    @ExcelCell(index = 3)
    private String type;//种类
    @ExcelCell(index = 4)
    private String simpleName;
    @ExcelCell(index = 5)
    private String cooperativeNumber;//合作商编号
    @ExcelCell(index = 6)
    private String addr;
    @ExcelCell(index = 7)
    private String emailCode;
    @ExcelCell(index = 8)
    private String city;
    @ExcelCell(index = 9)
    private String ttc;
    @ExcelCell(index = 10)
    private String tva;
    @ExcelCell(index = 11)
    private String tvaTwenty;//tva税率是否为20%  Y N
    public static Map<String,String> getColMap(){
        Map<String,String> map = new LinkedHashMap<>();
        map.put( "a", "DATE");//日期
        map.put( "b", "NO. FACTURE");//发票号
        map.put( "c", "LIBELLE");//种类
        map.put( "d", "NOM D`ENTREPRISE");//简名
        map.put( "e", "CODE COMPTA");//合作商编号
        map.put( "f", "ADRESSE");//地址
        map.put( "g", "CP");//邮编
        map.put( "h", "VILLE");//城市
        map.put( "i", "TTC");//TTC 金额
        map.put( "j", "TVA");//TVA 金额
        map.put( "k", "20P TVA");//是否为20%的税
        return map;
    }
}
